
# this example keeps the ad-id field in place, and pivots the spot type and cat fields
# into column headers, putting the quantity and revenue values under them.

<a href="zcat.html">zcat</a> Activity_123456_07-13-2006.log.gz |
	<b>pivot</b> -f 6 -p 18,19 -v 20,21 -k |
	<a href="csvformat.html">csvformat</a>

"Ad-ID","type0 - cat0: Quantity","type0 - cat0: Revenue","type0 - cat1: Quantity","type0 - cat1: Revenue","type0 - cat2: Quantity","type0 - cat2: Revenue","type0 - cat3: Quantity","type0 - cat3: Revenue","type0 - cat4: Quantity","type0 - cat4: Revenue"
"","95","0.00","1088","0.00","54","0.00","81","0.00","44","0.00"
"39113739","0","0.00","2","0.00","1","0.00","1","0.00","1","0.00"
"39114031","0","0.00","1","0.00","0","0.00","0","0.00","0","0.00"

